// ******************************************************************
// * Copyright(c)  Steven Lu
// * Description   : Schema_SALES_APP
// * CreateDate    : 2014-06-05 18:30:35
// * Creater       : CodeSmith
// * LastChangeDate: 2014-06-05 18:30:35
// * LastChanger   : 2014-06-05 18:30:35
// * Version Info  : 1.0 For ESOL
// ******************************************************************

using System;
using System.Collections.Generic;
using System.Text;
using Suzsoft.Smart.EntityCore;

namespace ESOL.Common.Schema
{
  	[Serializable]
    public partial class SalesAppTable : TableInfo
    {
		public const string C_TableName = "SALES_APP";
		
		public const string C_ID = "ID";
		public const string C_CREATED_BY = "CREATED_BY";
		public const string C_CREATED_DATE = "CREATED_DATE";
		public const string C_UPDATED_BY = "UPDATED_BY";
		public const string C_UPDATED_DATE = "UPDATED_DATE";
		public const string C_IS_ACTIVE = "IS_ACTIVE";
		public const string C_COMPANY_ID = "COMPANY_ID";
		public const string C_SOB_ID = "SOB_ID";
		public const string C_APP_NO = "APP_NO";
		public const string C_TYPE = "TYPE";
		public const string C_SO_NO = "SO_NO";
		public const string C_CUSTOMER_ID = "CUSTOMER_ID";
		public const string C_CUSTOMER_NAME = "CUSTOMER_NAME";
		public const string C_CUSTOMER_CODE = "CUSTOMER_CODE";
		public const string C_CONTACT_PERSON = "CONTACT_PERSON";
		public const string C_APP_PERSON = "APP_PERSON";
		public const string C_APP_DATE = "APP_DATE";
		public const string C_PAYMENT_TYPE = "PAYMENT_TYPE";
		public const string C_DELIVERY_ADD = "DELIVERY_ADD";
		public const string C_DELIVERY_PC = "DELIVERY_PC";
		public const string C_TRASPORT_TYPE = "TRASPORT_TYPE";
		public const string C_DELIVERY_TYPE = "DELIVERY_TYPE";
		public const string C_TOTAL_AMOUNT = "TOTAL_AMOUNT";
		public const string C_CURRENCY = "CURRENCY";
		public const string C_REMARK = "REMARK";
		public const string C_STATUS = "STATUS";
		
		public SalesAppTable()
        {
            _tableName = "SALES_APP";
        }
		
		protected static SalesAppTable _current;
        public static SalesAppTable Current
        {
            get
            {
                if (_current == null)
                {
                    Initial();
                }
                return _current;
            }
        }
		
		private static void Initial()
        {
            _current = new SalesAppTable();

            _current.Add(C_ID, new ColumnInfo(C_ID,"Id", true, typeof(string)));
            _current.Add(C_CREATED_BY, new ColumnInfo(C_CREATED_BY,"CreatedBy", false, typeof(string)));
            _current.Add(C_CREATED_DATE, new ColumnInfo(C_CREATED_DATE,"CreatedDate", false, typeof(DateTime)));
            _current.Add(C_UPDATED_BY, new ColumnInfo(C_UPDATED_BY,"UpdatedBy", false, typeof(string)));
            _current.Add(C_UPDATED_DATE, new ColumnInfo(C_UPDATED_DATE,"UpdatedDate", false, typeof(DateTime)));
            _current.Add(C_IS_ACTIVE, new ColumnInfo(C_IS_ACTIVE,"IsActive", false, typeof(int)));
            _current.Add(C_COMPANY_ID, new ColumnInfo(C_COMPANY_ID,"CompanyId", false, typeof(string)));
            _current.Add(C_SOB_ID, new ColumnInfo(C_SOB_ID,"SobId", false, typeof(string)));
            _current.Add(C_APP_NO, new ColumnInfo(C_APP_NO,"AppNo", false, typeof(string)));
            _current.Add(C_TYPE, new ColumnInfo(C_TYPE,"Type", false, typeof(string)));
            _current.Add(C_SO_NO, new ColumnInfo(C_SO_NO,"SoNo", false, typeof(string)));
            _current.Add(C_CUSTOMER_ID, new ColumnInfo(C_CUSTOMER_ID,"CustomerId", false, typeof(string)));
            _current.Add(C_CUSTOMER_NAME, new ColumnInfo(C_CUSTOMER_NAME,"CustomerName", false, typeof(string)));
            _current.Add(C_CUSTOMER_CODE, new ColumnInfo(C_CUSTOMER_CODE,"CustomerCode", false, typeof(string)));
            _current.Add(C_CONTACT_PERSON, new ColumnInfo(C_CONTACT_PERSON,"ContactPerson", false, typeof(string)));
            _current.Add(C_APP_PERSON, new ColumnInfo(C_APP_PERSON,"AppPerson", false, typeof(string)));
            _current.Add(C_APP_DATE, new ColumnInfo(C_APP_DATE,"AppDate", false, typeof(DateTime)));
            _current.Add(C_PAYMENT_TYPE, new ColumnInfo(C_PAYMENT_TYPE,"PaymentType", false, typeof(string)));
            _current.Add(C_DELIVERY_ADD, new ColumnInfo(C_DELIVERY_ADD,"DeliveryAdd", false, typeof(string)));
            _current.Add(C_DELIVERY_PC, new ColumnInfo(C_DELIVERY_PC,"DeliveryPc", false, typeof(string)));
            _current.Add(C_TRASPORT_TYPE, new ColumnInfo(C_TRASPORT_TYPE,"TrasportType", false, typeof(string)));
            _current.Add(C_DELIVERY_TYPE, new ColumnInfo(C_DELIVERY_TYPE,"DeliveryType", false, typeof(string)));
            _current.Add(C_TOTAL_AMOUNT, new ColumnInfo(C_TOTAL_AMOUNT,"TotalAmount", false, typeof(decimal)));
            _current.Add(C_CURRENCY, new ColumnInfo(C_CURRENCY,"Currency", false, typeof(string)));
            _current.Add(C_REMARK, new ColumnInfo(C_REMARK,"Remark", false, typeof(string)));
            _current.Add(C_STATUS, new ColumnInfo(C_STATUS,"Status", false, typeof(string)));
			
		}
		
		public ColumnInfo ID
        {
            get { return this[C_ID]; }
        }
		
		public ColumnInfo CREATED_BY
        {
            get { return this[C_CREATED_BY]; }
        }
		
		public ColumnInfo CREATED_DATE
        {
            get { return this[C_CREATED_DATE]; }
        }
		
		public ColumnInfo UPDATED_BY
        {
            get { return this[C_UPDATED_BY]; }
        }
		
		public ColumnInfo UPDATED_DATE
        {
            get { return this[C_UPDATED_DATE]; }
        }
		
		public ColumnInfo IS_ACTIVE
        {
            get { return this[C_IS_ACTIVE]; }
        }
		
		public ColumnInfo COMPANY_ID
        {
            get { return this[C_COMPANY_ID]; }
        }
		
		public ColumnInfo SOB_ID
        {
            get { return this[C_SOB_ID]; }
        }
		
		public ColumnInfo APP_NO
        {
            get { return this[C_APP_NO]; }
        }
		
		public ColumnInfo TYPE
        {
            get { return this[C_TYPE]; }
        }
		
		public ColumnInfo SO_NO
        {
            get { return this[C_SO_NO]; }
        }
		
		public ColumnInfo CUSTOMER_ID
        {
            get { return this[C_CUSTOMER_ID]; }
        }
		
		public ColumnInfo CUSTOMER_NAME
        {
            get { return this[C_CUSTOMER_NAME]; }
        }
		
		public ColumnInfo CUSTOMER_CODE
        {
            get { return this[C_CUSTOMER_CODE]; }
        }
		
		public ColumnInfo CONTACT_PERSON
        {
            get { return this[C_CONTACT_PERSON]; }
        }
		
		public ColumnInfo APP_PERSON
        {
            get { return this[C_APP_PERSON]; }
        }
		
		public ColumnInfo APP_DATE
        {
            get { return this[C_APP_DATE]; }
        }
		
		public ColumnInfo PAYMENT_TYPE
        {
            get { return this[C_PAYMENT_TYPE]; }
        }
		
		public ColumnInfo DELIVERY_ADD
        {
            get { return this[C_DELIVERY_ADD]; }
        }
		
		public ColumnInfo DELIVERY_PC
        {
            get { return this[C_DELIVERY_PC]; }
        }
		
		public ColumnInfo TRASPORT_TYPE
        {
            get { return this[C_TRASPORT_TYPE]; }
        }
		
		public ColumnInfo DELIVERY_TYPE
        {
            get { return this[C_DELIVERY_TYPE]; }
        }
		
		public ColumnInfo TOTAL_AMOUNT
        {
            get { return this[C_TOTAL_AMOUNT]; }
        }
		
		public ColumnInfo CURRENCY
        {
            get { return this[C_CURRENCY]; }
        }
		
		public ColumnInfo REMARK
        {
            get { return this[C_REMARK]; }
        }
		
		public ColumnInfo STATUS
        {
            get { return this[C_STATUS]; }
        }
		
		
		
	}
}

